package com.wfs.myapp.repository.bk;

import com.wfs.myapp.entity.domain.bk.BkTalkRecord;
import com.wfs.myapp.entity.vo.OrderVo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Optional;

@Repository
public interface TalkRecordRepository extends JpaRepository<BkTalkRecord, Long> {

    @Query(nativeQuery = true, value = " SELECT tr.* " +
            " FROM bk_talk_record tr " +
            " WHERE tr.session_id = :sessionId"
    )
    Optional<BkTalkRecord> findBySessionId(String sessionId);
}




